Dataset statistics
| Number of variables | 35 |
|---|---|
| Number of observations | 687 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 188.0 KiB |
| Average record size in memory | 280.2 B |
Variable types
| BOOL | 23 |
|---|---|
| NUM | 10 |
| CAT | 1 |
| DATE | 1 |
trading_global_discount_app has constant value "687" | Constant |
trading_global_event2 has constant value "687" | Constant |
Unnamed: 0.1 is highly correlated with Unnamed: 0 | High correlation |
Unnamed: 0 is highly correlated with Unnamed: 0.1 | High correlation |
Unnamed: 0 has unique values | Unique |
Unnamed: 0.1 has unique values | Unique |
date has unique values | Unique |
GR_stringency_index has 379 (55.2%) zeros | Zeros |
delivery_express_days has 23 (3.3%) zeros | Zeros |
weekday_date has 98 (14.3%) zeros | Zeros |
Reproduction
| Analysis started | 2021-03-25 17:25:33.400133 |
|---|---|
| Analysis finished | 2021-03-25 17:25:47.441881 |
| Duration | 14.04 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 687 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 343 |
|---|---|
| Minimum | 0 |
| Maximum | 686 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 34.3 |
| Q1 | 171.5 |
| median | 343 |
| Q3 | 514.5 |
| 95-th percentile | 651.7 |
| Maximum | 686 |
| Range | 686 |
| Interquartile range (IQR) | 343 |
Descriptive statistics
| Standard deviation | 198.4641025 |
|---|---|
| Coefficient of variation (CV) | 0.5786125439 |
| Kurtosis | -1.2 |
| Mean | 343 |
| Median Absolute Deviation (MAD) | 172 |
| Skewness | 0 |
| Sum | 235641 |
| Variance | 39388 |
| Monotocity | Strictly increasing |
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.1% | |
| 461 | 1 | 0.1% | |
| 453 | 1 | 0.1% | |
| 454 | 1 | 0.1% | |
| 455 | 1 | 0.1% | |
| 456 | 1 | 0.1% | |
| 457 | 1 | 0.1% | |
| 458 | 1 | 0.1% | |
| 459 | 1 | 0.1% | |
| 460 | 1 | 0.1% | |
| Other values (677) | 677 | 98.5% |
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.1% | |
| 1 | 1 | 0.1% | |
| 2 | 1 | 0.1% | |
| 3 | 1 | 0.1% | |
| 4 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 686 | 1 | 0.1% | |
| 685 | 1 | 0.1% | |
| 684 | 1 | 0.1% | |
| 683 | 1 | 0.1% | |
| 682 | 1 | 0.1% |
| Distinct | 687 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 343 |
|---|---|
| Minimum | 0 |
| Maximum | 686 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 34.3 |
| Q1 | 171.5 |
| median | 343 |
| Q3 | 514.5 |
| 95-th percentile | 651.7 |
| Maximum | 686 |
| Range | 686 |
| Interquartile range (IQR) | 343 |
Descriptive statistics
| Standard deviation | 198.4641025 |
|---|---|
| Coefficient of variation (CV) | 0.5786125439 |
| Kurtosis | -1.2 |
| Mean | 343 |
| Median Absolute Deviation (MAD) | 172 |
| Skewness | 0 |
| Sum | 235641 |
| Variance | 39388 |
| Monotocity | Strictly increasing |
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.1% | |
| 461 | 1 | 0.1% | |
| 453 | 1 | 0.1% | |
| 454 | 1 | 0.1% | |
| 455 | 1 | 0.1% | |
| 456 | 1 | 0.1% | |
| 457 | 1 | 0.1% | |
| 458 | 1 | 0.1% | |
| 459 | 1 | 0.1% | |
| 460 | 1 | 0.1% | |
| Other values (677) | 677 | 98.5% |
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.1% | |
| 1 | 1 | 0.1% | |
| 2 | 1 | 0.1% | |
| 3 | 1 | 0.1% | |
| 4 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 686 | 1 | 0.1% | |
| 685 | 1 | 0.1% | |
| 684 | 1 | 0.1% | |
| 683 | 1 | 0.1% | |
| 682 | 1 | 0.1% |
| Distinct | 687 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| Minimum | 2019-01-01 00:00:00 |
|---|---|
| Maximum | 2020-11-17 00:00:00 |
units_sold
Real number (ℝ≥0)
| Distinct | 655 |
|---|---|
| Distinct (%) | 95.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9847.708879 |
|---|---|
| Minimum | 4105 |
| Maximum | 39019 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 4105 |
|---|---|
| 5-th percentile | 6359 |
| Q1 | 7830.5 |
| median | 9071 |
| Q3 | 10775 |
| 95-th percentile | 16438.7 |
| Maximum | 39019 |
| Range | 34914 |
| Interquartile range (IQR) | 2944.5 |
Descriptive statistics
| Standard deviation | 3596.058903 |
|---|---|
| Coefficient of variation (CV) | 0.3651670604 |
| Kurtosis | 14.38853721 |
| Mean | 9847.708879 |
| Median Absolute Deviation (MAD) | 1441 |
| Skewness | 2.911538442 |
| Sum | 6765376 |
| Variance | 12931639.64 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 8423 | 3 | 0.4% | |
| 8944 | 2 | 0.3% | |
| 7233 | 2 | 0.3% | |
| 7321 | 2 | 0.3% | |
| 10397 | 2 | 0.3% | |
| 8170 | 2 | 0.3% | |
| 9248 | 2 | 0.3% | |
| 8582 | 2 | 0.3% | |
| 10620 | 2 | 0.3% | |
| 9480 | 2 | 0.3% | |
| Other values (645) | 666 | 96.9% |
| Value | Count | Frequency (%) | |
| 4105 | 1 | 0.1% | |
| 4155 | 1 | 0.1% | |
| 4204 | 1 | 0.1% | |
| 4210 | 1 | 0.1% | |
| 4253 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 39019 | 1 | 0.1% | |
| 35787 | 1 | 0.1% | |
| 32417 | 1 | 0.1% | |
| 27501 | 1 | 0.1% | |
| 26464 | 1 | 0.1% |
| Distinct | 20 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.04221252 |
|---|---|
| Minimum | 0 |
| Maximum | 76 |
| Zeros | 379 |
| Zeros (%) | 55.2% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 64 |
| 95-th percentile | 76 |
| Maximum | 76 |
| Range | 76 |
| Interquartile range (IQR) | 64 |
Descriptive statistics
| Standard deviation | 31.83498305 |
|---|---|
| Coefficient of variation (CV) | 1.271252811 |
| Kurtosis | -1.571686612 |
| Mean | 25.04221252 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.593938682 |
| Sum | 17204 |
| Variance | 1013.466146 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 379 | 55.2% | |
| 62 | 52 | 7.6% | |
| 76 | 48 | 7.0% | |
| 64 | 45 | 6.6% | |
| 10 | 40 | 5.8% | |
| 68 | 35 | 5.1% | |
| 72 | 18 | 2.6% | |
| 66 | 17 | 2.5% | |
| 60 | 14 | 2.0% | |
| 6 | 11 | 1.6% | |
| Other values (10) | 28 | 4.1% |
| Value | Count | Frequency (%) | |
| 0 | 379 | 55.2% | |
| 6 | 11 | 1.6% | |
| 8 | 2 | 0.3% | |
| 10 | 40 | 5.8% | |
| 12 | 3 | 0.4% |
| Value | Count | Frequency (%) | |
| 76 | 48 | 7.0% | |
| 74 | 3 | 0.4% | |
| 72 | 18 | 2.6% | |
| 70 | 7 | 1.0% | |
| 68 | 35 | 5.1% |
weather_temperature
Real number (ℝ)
| Distinct | 211 |
|---|---|
| Distinct (%) | 30.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.23580786 |
|---|---|
| Minimum | -0.4 |
| Maximum | 28.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | -0.4 |
|---|---|
| 5-th percentile | 4.53 |
| Q1 | 8.1 |
| median | 11.7 |
| Q3 | 16.5 |
| 95-th percentile | 20.37 |
| Maximum | 28.2 |
| Range | 28.6 |
| Interquartile range (IQR) | 8.4 |
Descriptive statistics
| Standard deviation | 5.235199758 |
|---|---|
| Coefficient of variation (CV) | 0.4278589381 |
| Kurtosis | -0.5126658685 |
| Mean | 12.23580786 |
| Median Absolute Deviation (MAD) | 4.1 |
| Skewness | 0.2208301646 |
| Sum | 8406 |
| Variance | 27.40731651 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 9.6 | 10 | 1.5% | |
| 6.9 | 9 | 1.3% | |
| 9.2 | 9 | 1.3% | |
| 9.1 | 9 | 1.3% | |
| 7.4 | 8 | 1.2% | |
| 18.3 | 8 | 1.2% | |
| 6.8 | 8 | 1.2% | |
| 7.2 | 7 | 1.0% | |
| 8.2 | 7 | 1.0% | |
| 16.6 | 7 | 1.0% | |
| Other values (201) | 605 | 88.1% |
| Value | Count | Frequency (%) | |
| -0.4 | 1 | 0.1% | |
| 0.8 | 1 | 0.1% | |
| 1 | 1 | 0.1% | |
| 1.1 | 1 | 0.1% | |
| 1.3 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 28.2 | 1 | 0.1% | |
| 27 | 1 | 0.1% | |
| 26.5 | 1 | 0.1% | |
| 25.9 | 1 | 0.1% | |
| 25.6 | 1 | 0.1% |
marketing_spend
Real number (ℝ≥0)
| Distinct | 675 |
|---|---|
| Distinct (%) | 98.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2385.117467 |
|---|---|
| Minimum | 141 |
| Maximum | 7244 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 141 |
|---|---|
| 5-th percentile | 309.06 |
| Q1 | 2029 |
| median | 2274.7 |
| Q3 | 2742.05 |
| 95-th percentile | 4042.97 |
| Maximum | 7244 |
| Range | 7103 |
| Interquartile range (IQR) | 713.05 |
Descriptive statistics
| Standard deviation | 951.2724502 |
|---|---|
| Coefficient of variation (CV) | 0.3988367295 |
| Kurtosis | 3.337014264 |
| Mean | 2385.117467 |
| Median Absolute Deviation (MAD) | 326.4 |
| Skewness | 0.6146360491 |
| Sum | 1638575.7 |
| Variance | 904919.2745 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 2080.7 | 2 | 0.3% | |
| 284.4 | 2 | 0.3% | |
| 2482.8 | 2 | 0.3% | |
| 2829.7 | 2 | 0.3% | |
| 2708.8 | 2 | 0.3% | |
| 2307.6 | 2 | 0.3% | |
| 2174.3 | 2 | 0.3% | |
| 2119.4 | 2 | 0.3% | |
| 2178.1 | 2 | 0.3% | |
| 292.3 | 2 | 0.3% | |
| Other values (665) | 667 | 97.1% |
| Value | Count | Frequency (%) | |
| 141 | 1 | 0.1% | |
| 151 | 1 | 0.1% | |
| 159.8 | 1 | 0.1% | |
| 161 | 1 | 0.1% | |
| 171 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 7244 | 1 | 0.1% | |
| 6746.7 | 1 | 0.1% | |
| 6630.2 | 1 | 0.1% | |
| 6249.4 | 1 | 0.1% | |
| 6016.4 | 1 | 0.1% |
delivery_standard_days
Real number (ℝ≥0)
| Distinct | 41 |
|---|---|
| Distinct (%) | 6.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.188355167 |
|---|---|
| Minimum | 2 |
| Maximum | 14 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 8 |
| Maximum | 14 |
| Range | 12 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2.068896003 |
|---|---|
| Coefficient of variation (CV) | 0.4939638404 |
| Kurtosis | 5.755584846 |
| Mean | 4.188355167 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.234697646 |
| Sum | 2877.4 |
| Variance | 4.280330673 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 3 | 303 | 44.1% | |
| 4 | 107 | 15.6% | |
| 5 | 74 | 10.8% | |
| 6 | 56 | 8.2% | |
| 2 | 42 | 6.1% | |
| 8 | 15 | 2.2% | |
| 7 | 14 | 2.0% | |
| 11 | 11 | 1.6% | |
| 3.1 | 8 | 1.2% | |
| 13 | 6 | 0.9% | |
| Other values (31) | 51 | 7.4% |
| Value | Count | Frequency (%) | |
| 2 | 42 | 6.1% | |
| 2.1 | 1 | 0.1% | |
| 2.3 | 1 | 0.1% | |
| 2.6 | 1 | 0.1% | |
| 2.7 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 14 | 2 | 0.3% | |
| 13 | 6 | 0.9% | |
| 12.2 | 1 | 0.1% | |
| 12 | 2 | 0.3% | |
| 11.8 | 1 | 0.1% |
| Distinct | 35 |
|---|---|
| Distinct (%) | 5.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.103202329 |
|---|---|
| Minimum | 0 |
| Maximum | 5.1 |
| Zeros | 23 |
| Zeros (%) | 3.3% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1.2 |
| 95-th percentile | 2.1 |
| Maximum | 5.1 |
| Range | 5.1 |
| Interquartile range (IQR) | 0.2 |
Descriptive statistics
| Standard deviation | 0.6464220373 |
|---|---|
| Coefficient of variation (CV) | 0.5859505734 |
| Kurtosis | 9.185607543 |
| Mean | 1.103202329 |
| Median Absolute Deviation (MAD) | 0.1 |
| Skewness | 2.149683465 |
| Sum | 757.9 |
| Variance | 0.4178614503 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 258 | 37.6% | |
| 1.1 | 115 | 16.7% | |
| 1.2 | 42 | 6.1% | |
| 1.3 | 41 | 6.0% | |
| 0.2 | 41 | 6.0% | |
| 1.4 | 23 | 3.3% | |
| 0 | 23 | 3.3% | |
| 0.9 | 22 | 3.2% | |
| 0.1 | 15 | 2.2% | |
| 2 | 13 | 1.9% | |
| Other values (25) | 94 | 13.7% |
| Value | Count | Frequency (%) | |
| 0 | 23 | 3.3% | |
| 0.1 | 15 | 2.2% | |
| 0.2 | 41 | 6.0% | |
| 0.3 | 2 | 0.3% | |
| 0.4 | 6 | 0.9% |
| Value | Count | Frequency (%) | |
| 5.1 | 1 | 0.1% | |
| 5 | 2 | 0.3% | |
| 4 | 3 | 0.4% | |
| 3.9 | 1 | 0.1% | |
| 3.7 | 1 | 0.1% |
trading_global_sale1
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 473 | 68.9% | |
| 1 | 214 | 31.1% |
trading_global_sale2
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 | |
|---|---|
| 1 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 686 | 99.9% | |
| 1 | 1 | 0.1% |
trading_global_promotion
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 390 | 56.8% | |
| 0 | 297 | 43.2% |
trading_global_flashsale
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 | |
|---|---|
| 1 | 5 |
| Value | Count | Frequency (%) | |
| 0 | 682 | 99.3% | |
| 1 | 5 | 0.7% |
trading_global_spendnsave
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 | |
|---|---|
| 1 | 15 |
| Value | Count | Frequency (%) | |
| 0 | 672 | 97.8% | |
| 1 | 15 | 2.2% |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 | |
|---|---|
| 1 | 45 |
| Value | Count | Frequency (%) | |
| 0 | 642 | 93.4% | |
| 1 | 45 | 6.6% |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 |
|---|
| Value | Count | Frequency (%) | |
| 0 | 687 | 100.0% |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 | |
|---|---|
| 1 | 2 |
| Value | Count | Frequency (%) | |
| 0 | 685 | 99.7% | |
| 1 | 2 | 0.3% |
trading_global_event1
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 | |
|---|---|
| 1 | 9 |
| Value | Count | Frequency (%) | |
| 0 | 678 | 98.7% | |
| 1 | 9 | 1.3% |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 |
|---|
| Value | Count | Frequency (%) | |
| 0 | 687 | 100.0% |
trading_local_sale1
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 | |
|---|---|
| 1 | 37 |
| Value | Count | Frequency (%) | |
| 0 | 650 | 94.6% | |
| 1 | 37 | 5.4% |
trading_local_sale2
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 622 | 90.5% | |
| 1 | 65 | 9.5% |
trading_local_promotion
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 | |
|---|---|
| 1 | 42 |
| Value | Count | Frequency (%) | |
| 0 | 645 | 93.9% | |
| 1 | 42 | 6.1% |
trading_local_flashsale
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 | |
|---|---|
| 1 | 14 |
| Value | Count | Frequency (%) | |
| 0 | 673 | 98.0% | |
| 1 | 14 | 2.0% |
trading_local_spendnsave
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 | |
|---|---|
| 1 | 27 |
| Value | Count | Frequency (%) | |
| 0 | 660 | 96.1% | |
| 1 | 27 | 3.9% |
trading_local_discount_extra
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 | |
|---|---|
| 1 | 46 |
| Value | Count | Frequency (%) | |
| 0 | 641 | 93.3% | |
| 1 | 46 | 6.7% |
trading_local_discount_app
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 | |
|---|---|
| 1 | 18 |
| Value | Count | Frequency (%) | |
| 0 | 669 | 97.4% | |
| 1 | 18 | 2.6% |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 | |
|---|---|
| 1 | 25 |
| Value | Count | Frequency (%) | |
| 0 | 662 | 96.4% | |
| 1 | 25 | 3.6% |
trading_local_event1
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 | |
|---|---|
| 1 | 2 |
| Value | Count | Frequency (%) | |
| 0 | 685 | 99.7% | |
| 1 | 2 | 0.3% |
trading_local_event2
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 | |
|---|---|
| 1 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 686 | 99.9% | |
| 1 | 1 | 0.1% |
weather_cloudy
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 397 | 57.8% | |
| 1 | 290 | 42.2% |
weather_rainy
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 615 | 89.5% | |
| 1 | 72 | 10.5% |
weather_clear
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 362 | 52.7% | |
| 1 | 325 | 47.3% |
year_date
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 2019 | |
|---|---|
| 2020 |
| Value | Count | Frequency (%) | |
| 2019 | 365 | 53.1% | |
| 2020 | 322 | 46.9% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
month_date
Real number (ℝ≥0)
| Distinct | 12 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.187772926 |
|---|---|
| Minimum | 1 |
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 11 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.29120599 |
|---|---|
| Coefficient of variation (CV) | 0.531888618 |
| Kurtosis | -1.152459655 |
| Mean | 6.187772926 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.03742277812 |
| Sum | 4251 |
| Variance | 10.83203687 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 62 | 9.0% | |
| 3 | 62 | 9.0% | |
| 5 | 62 | 9.0% | |
| 7 | 62 | 9.0% | |
| 8 | 62 | 9.0% | |
| 10 | 62 | 9.0% | |
| 4 | 60 | 8.7% | |
| 6 | 60 | 8.7% | |
| 9 | 60 | 8.7% | |
| 2 | 57 | 8.3% | |
| Other values (2) | 78 | 11.4% |
| Value | Count | Frequency (%) | |
| 1 | 62 | 9.0% | |
| 2 | 57 | 8.3% | |
| 3 | 62 | 9.0% | |
| 4 | 60 | 8.7% | |
| 5 | 62 | 9.0% |
| Value | Count | Frequency (%) | |
| 12 | 31 | 4.5% | |
| 11 | 47 | 6.8% | |
| 10 | 62 | 9.0% | |
| 9 | 60 | 8.7% | |
| 8 | 62 | 9.0% |
| Distinct | 7 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.997088792 |
|---|---|
| Minimum | 0 |
| Maximum | 6 |
| Zeros | 98 |
| Zeros (%) | 14.3% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.001455075 |
|---|---|
| Coefficient of variation (CV) | 0.6677997263 |
| Kurtosis | -1.251448651 |
| Mean | 2.997088792 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.002917585377 |
| Sum | 2059 |
| Variance | 4.005822416 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 99 | 14.4% | |
| 0 | 98 | 14.3% | |
| 2 | 98 | 14.3% | |
| 3 | 98 | 14.3% | |
| 4 | 98 | 14.3% | |
| 5 | 98 | 14.3% | |
| 6 | 98 | 14.3% |
| Value | Count | Frequency (%) | |
| 0 | 98 | 14.3% | |
| 1 | 99 | 14.4% | |
| 2 | 98 | 14.3% | |
| 3 | 98 | 14.3% | |
| 4 | 98 | 14.3% |
| Value | Count | Frequency (%) | |
| 6 | 98 | 14.3% | |
| 5 | 98 | 14.3% | |
| 4 | 98 | 14.3% | |
| 3 | 98 | 14.3% | |
| 2 | 98 | 14.3% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Unnamed: 0 | Unnamed: 0.1 | date | units_sold | GR_stringency_index | weather_temperature | marketing_spend | delivery_standard_days | delivery_express_days | trading_global_sale1 | trading_global_sale2 | trading_global_promotion | trading_global_flashsale | trading_global_spendnsave | trading_global_discount_extra | trading_global_discount_app | trading_global_discount_student | trading_global_event1 | trading_global_event2 | trading_local_sale1 | trading_local_sale2 | trading_local_promotion | trading_local_flashsale | trading_local_spendnsave | trading_local_discount_extra | trading_local_discount_app | trading_local_discount_student | trading_local_event1 | trading_local_event2 | weather_cloudy | weather_rainy | weather_clear | year_date | month_date | weekday_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 0 | 2019-01-01 | 7408.0 | 0.0 | 7.2 | 2367.4 | 4.0 | 1.1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2019 | 1 | 1 |
| 1 | 1 | 1 | 2019-01-02 | 7163.0 | 0.0 | 9.1 | 2377.9 | 4.0 | 1.1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2019 | 1 | 2 |
| 2 | 2 | 2 | 2019-01-03 | 8043.0 | 0.0 | 6.8 | 2388.4 | 4.0 | 1.1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2019 | 1 | 3 |
| 3 | 3 | 3 | 2019-01-04 | 7395.0 | 0.0 | 3.8 | 2398.9 | 4.0 | 1.1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2019 | 1 | 4 |
| 4 | 4 | 4 | 2019-01-05 | 7294.0 | 0.0 | 2.9 | 2409.4 | 4.0 | 1.1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2019 | 1 | 5 |
| 5 | 5 | 5 | 2019-01-06 | 6249.0 | 0.0 | 7.0 | 2419.1 | 4.0 | 1.1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2019 | 1 | 6 |
| 6 | 6 | 6 | 2019-01-07 | 6369.0 | 0.0 | 8.6 | 2428.9 | 4.0 | 1.1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2019 | 1 | 0 |
| 7 | 7 | 7 | 2019-01-08 | 7431.0 | 0.0 | 10.3 | 2438.7 | 4.0 | 1.1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2019 | 1 | 1 |
| 8 | 8 | 8 | 2019-01-09 | 8072.0 | 0.0 | 7.6 | 2448.5 | 4.0 | 1.1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 2019 | 1 | 2 |
| 9 | 9 | 9 | 2019-01-10 | 8117.0 | 0.0 | 6.6 | 2458.3 | 4.0 | 1.1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 2019 | 1 | 3 |
Last rows
| Unnamed: 0 | Unnamed: 0.1 | date | units_sold | GR_stringency_index | weather_temperature | marketing_spend | delivery_standard_days | delivery_express_days | trading_global_sale1 | trading_global_sale2 | trading_global_promotion | trading_global_flashsale | trading_global_spendnsave | trading_global_discount_extra | trading_global_discount_app | trading_global_discount_student | trading_global_event1 | trading_global_event2 | trading_local_sale1 | trading_local_sale2 | trading_local_promotion | trading_local_flashsale | trading_local_spendnsave | trading_local_discount_extra | trading_local_discount_app | trading_local_discount_student | trading_local_event1 | trading_local_event2 | weather_cloudy | weather_rainy | weather_clear | year_date | month_date | weekday_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 677 | 677 | 677 | 2020-11-08 | 8657.0 | 60.0 | 10.7 | 4598.4 | 3.0 | 0.9 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2020 | 11 | 6 |
| 678 | 678 | 678 | 2020-11-09 | 9209.0 | 60.0 | 12.4 | 4479.4 | 3.0 | 0.2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2020 | 11 | 0 |
| 679 | 679 | 679 | 2020-11-10 | 10182.0 | 60.0 | 10.7 | 4360.4 | 3.0 | 1.1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2020 | 11 | 1 |
| 680 | 680 | 680 | 2020-11-11 | 15157.0 | 60.0 | 10.5 | 4241.5 | 3.0 | 1.1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 2020 | 11 | 2 |
| 681 | 681 | 681 | 2020-11-12 | 13348.0 | 60.0 | 12.9 | 4122.5 | 3.0 | 1.2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 2020 | 11 | 3 |
| 682 | 682 | 682 | 2020-11-13 | 14180.0 | 60.0 | 12.1 | 4003.5 | 4.0 | 1.4 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 2020 | 11 | 4 |
| 683 | 683 | 683 | 2020-11-14 | 10397.0 | 60.0 | 7.8 | 3884.5 | 4.0 | 1.6 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2020 | 11 | 5 |
| 684 | 684 | 684 | 2020-11-15 | 13498.0 | 60.0 | 6.3 | 4274.1 | 3.0 | 0.7 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2020 | 11 | 6 |
| 685 | 685 | 685 | 2020-11-16 | 12230.0 | 60.0 | 11.0 | 4663.7 | 3.0 | 0.2 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2020 | 11 | 0 |
| 686 | 686 | 686 | 2020-11-17 | 12676.0 | 60.0 | 9.3 | 5053.3 | 3.0 | 1.6 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2020 | 11 | 1 |